<?php
session_start();
/*
 * Session variables:
 * $_SESSION['type'] [string] = user type of the logged in user
 * $_SESSION['authorised'] [boolean] = whether or not the current user is logged in
 */

if (isset($_SESSION['authorised']) && $_SESSION['authorised'] == true) {
    if (isset($_SESSION['type'])) {
        if ($_SESSION['type'] == 'administrator') {
?>
            <html xmlns="http://www.w3.org/1999/xhtml">
                <head>
                <script>
	function setOptions1(chosen) 
	{
		var selbox = document.myform.startday;
		selbox.options.length = 0;
		
		if (chosen == "Jan" || chosen == "Mar" || chosen == "May" || chosen == "Jul" || chosen == "Aug" || chosen == "Oct" || chosen == "Dec")
		{
		  <?php 
		  for($i=1; $i < 32; $i++)
		  {
		  	print ("selbox.options[selbox.options.length] = new Option(\"$i\",\"$i\");\n");
		  }
		  ?>
		}
		else if (chosen == "Feb")
		{
		  <?php 
		  for($i=1; $i < 29; $i++)
		  {
		  	print ("selbox.options[selbox.options.length] = new Option(\"$i\",\"$i\");\n");
		  }
		  ?>
		}
		else
		{
		  <?php 
		  for($i=1; $i < 31; $i++)
		  {
		  	print ("selbox.options[selbox.options.length] = new Option(\"$i\",\"$i\");\n");
		  }
		  ?>
		}
		
		
	}
			</script>
			      <script>
	function setOptions2(chosen) 
	{
		var selbox2 = document.myform.endday;
		selbox2.options.length = 0;
		
		if (chosen == "Jan" || chosen == "Mar" || chosen == "May" || chosen == "Jul" || chosen == "Aug" || chosen == "Oct" || chosen == "Dec")
		{
		  <?php 
		  for($i=1; $i < 32; $i++)
		  {
		  	print ("selbox2.options[selbox2.options.length] = new Option(\"$i\",\"$i\");\n");
		  }
		  ?>
		}
		else if (chosen == "Feb")
		{
		  <?php 
		  for($i=1; $i < 29; $i++)
		  {
		  	print ("selbox2.options[selbox2.options.length] = new Option(\"$i\",\"$i\");\n");
		  }
		  ?>
		}
		else
		{
		  <?php 
		  for($i=1; $i < 31; $i++)
		  {
		  	print ("selbox2.options[selbox2.options.length] = new Option(\"$i\",\"$i\");\n");
		  }
		  ?>
		}
		
		
	}
			</script>
    
                    <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
                    <title>Class Creation</title>
                    <link href="StyleSheet.css" rel="stylesheet" type="text/css" />
                    <style>
                        .nav {
                            width:210px;
                            height:auto;
                            border:thin solid #09C;

                            margin-left: 10px;
                            text-align : center;}

                        .mainline {
                            width:712px;

                            height:auto;
                            text-align : center;}
                        </style>
                    </head>

                    <center>
                        <body bgcolor="#FFFFFF">
                            <div id="wrapper">
                            <div id="header">
                                <h1></h1>
                            </div>
                            <div id="header2">
                                <h3></h3>
                            </div>

                            <div id="nav">
                              <?php include 'admin_navigation.php';?>
                            </div>
                            <div id="mainline">
                                <h4> Create a New Class </h4>
                                <div id="body">                                    
                                    <form name="myform" action="admin_creating_class.php" method="post">
                                        <table width="712" cellpadding="2" class="infotable" align="left">
                                           <tr align="left">
                                                <th height="42" scope="row">Subject:</th>
                                                <td>
                                                    <input type="text" size="50" maxlength="256" id="subject" name="subject"/>
                                                </td>
                                            </tr>
                                            <tr align="left">
                                                <th height="42" scope="row">Section:</th>
                                                <td>
                                                    <input type="text" size="50" maxlength="256" id="section" name="section"/>
                                                </td>
                                            </tr>
                                            <tr align="left">
                                                <th height="42" scope="row">Tutor:</th>
                                                <td>
                                                   <select name="tutor">
                                                   <?php 
                                                   include('connection.inc');
	                                                   	$sql = "SELECT * FROM teachers natural join users order by lastname";
														$result = pg_query($sql);
														$count = pg_num_rows($result);
											            for($i = 0; $i < $count; $i++)
											            {
															$teacher_id= pg_fetch_result($result, $i, 'teacher_id');
															$lastname= pg_fetch_result($result, $i, 'lastname');
															$firstname= pg_fetch_result($result, $i, 'firstname');
											            	echo "<option value=\"$teacher_id\">$lastname, $firstname</option>";
											            }
													?>
                                                   </select>
                                                </td>
                                            </tr>
                                            <tr align="left">
                                                <th height="42" scope="row">Room:</th>
                                                <td>
                                                   <select name="room">
                                                   <?php 
                                                   include('connection.inc');
	                                                   	$sql = "SELECT * FROM rooms natural join buildings order by room_number";
														$result = pg_query($sql);
														$count = pg_num_rows($result);
											            for($i = 0; $i < $count; $i++)
											            {
															$room_id= pg_fetch_result($result, $i, 'room_id');
															$room_number= pg_fetch_result($result, $i, 'room_number');
															$building_name= pg_fetch_result($result, $i, 'building_name');
											            	echo "<option value=\"$room_id\">$room_number in $building_name</option>";
											            }
													?>
                                                   </select>
                                                </td>
                                            </tr>
                                             <tr align="left">
                                                <th height="42" scope="row">Start Time:</th>
                                                <td>
                                                    <select name="starthr">
                                                              <?php 
											            for($i = 1; $i < 13; $i++)
											            {
											            	echo "<option value=\"$i\">$i</option>";
											            }
													?>                                              
                                                    </select>
                                                    :<select name="startmin">
                                                     <?php 
        												for($i = 0; $i < 10; $i++)
											            {
											            	echo "<option value=\"0$i\">0$i</option>";
											            }
                                                     	for($i = 10; $i < 61; $i++)
											            {
											            	echo "<option value=\"$i\">$i</option>";
											            }
													?>                                        
                                                    </select>
                                                    <select name="start">
                                                                    <option value="AM">AM</option>
                                                            <option value="PM">PM</option>                                        
                                                    </select>
                                                </td>
                                            </tr>
                                             <tr align="left">
                                                <th height="42" scope="row">End Time:</th>
                                                <td>
                                                   <select name="endhr">
                                                    <?php 
											            for($i = 1; $i < 13; $i++)
											            {
											            	echo "<option value=\"$i\">$i</option>";
											            }
													?>                                              
                                                    </select>
                                                    :<select name="endmin">
                                                            <?php 
        for($i = 0; $i < 10; $i++)
											            {
											            	echo "<option value=\"0$i\">0$i</option>";
											            }
                                                     	for($i = 10; $i < 61; $i++)
											            {
											            	echo "<option value=\"$i\">$i</option>";
											            }
													?>                                               
                                                    </select>
                                                    <select name="end">
                                                            <option value="AM">AM</option>
                                                            <option value="PM">PM</option>                                            
                                                    </select>
                                                </td>
                                            </tr>
                                            	<tr height="40">
								<th align="left">Start Date:</th>
								<td><select name="startmonth" onchange="setOptions1(document.myform.startmonth.options[document.myform.startmonth.selectedIndex].value);">
									<option value="" selected="selected">MONTH</option>
									<option value="Jan">January</option>
									<option value="Feb">Febuary</option>
									<option value="Mar">March</option>
									<option value="Apr">April</option>
									<option value="May">May</option>
									<option value="Jun">June</option>
									<option value="Jul">July</option>
									<option value="Aug">August</option>
									<option value="Sep">September</option>
									<option value="Oct">October</option>
									<option value="Nov">November</option>
									<option value="Dec">December</option>
								</select>
								<select name="startday">
									<option value="" selected="selected">DAY</option>
								</select>
								<select name="startyear">
									<?php
										for($i=2000; $i<2021; $i++)
										{
											echo "<option value=$i>$i</option>";
										}
									?>
								</select>
								</td>
							</tr>        
							<th align="left">End Date:</th>
								<td><select name="endmonth" onchange="setOptions2(document.myform.endmonth.options[document.myform.endmonth.selectedIndex].value);">
									<option value="" selected="selected">MONTH</option>
									<option value="Jan">January</option>
									<option value="Feb">Febuary</option>
									<option value="Mar">March</option>
									<option value="Apr">April</option>
									<option value="May">May</option>
									<option value="Jun">June</option>
									<option value="Jul">July</option>
									<option value="Aug">August</option>
									<option value="Sep">September</option>
									<option value="Oct">October</option>
									<option value="Nov">November</option>
									<option value="Dec">December</option>
								</select>
								<select name="endday">
									<option value="" selected="selected">DAY</option>
								</select>
								<select name="endyear">
									<?php
										for($i=2000; $i<2021; $i++)
										{
											echo "<option value=$i>$i</option>";
										}
									?>
								</select>
								</td>
								</tr>
								<tr align="left">
                                    <th>Open for online reservations?</th>
                                    <td><select name="for_reservation">
									        <option value="true">YES</option>
									        <option value="false">NO</option>
								        </select>
								    </td>
                                </tr>
								    <tr align="left">
                                                <td></td>
                                                <td><input type = "submit" value ="Submit" /></td>
                                            </tr>
                                        </table>
                                    </form>
                                </div>
                            </div>



                            <p align="justify"><br /></p>
                        

                        <br class="clearfloat"/>
                        <br />

                        <div id="footer">
                            <p align="center">
                                Tutorial Business Manager: info@tbms.com <br />Credits/Engineers: Aquino, Chloebelle; Dela Cruz, Roy Erwin; Maliwanag, Ranyel Bryan; Manzano, Audrey Ann; Ng, Sheila Regine<br />
                                <br />copyright 2011</p>
                        </div>
                        </div>
                    </body>
                </center>
            </html>
<?php
        } elseif ($_SESSION['type'] == 'student') {
            header('Location: student_index.php');
            exit();
        } elseif ($_SESSION['type'] == 'tutor') {
            header('Location: tutor_index.php');
            exit();
        } elseif ($_SESSION['type'] == 'parent') {
            header('Location: parent_index.php');
            exit();
        }
    }
} else {
    header('Location: index.php');
}
?>
